using System;
using System.Data;
using BeeldBank.Data.Sql;
using System.Data.SqlClient;

namespace BeeldBank.Data
{
	/// <summary>
	/// Provides database independant methods for OrderRegel.
	/// </summary>
	public class OrderRegel : OrderRegelBase
	{
		/// <summary>
		/// Creates a DataTable containing records from the BEELDBANK_ORDERREGEL table with OrderId as specified in the argument completed with the label fields of associated tables.
		/// </summary>
		/// <param name="OrderId">Argument that is used to retrieve the data.</param>
		public static DataTable CustomShowFromOrderId ( int OrderId ) {
			SqlParameter sqlParameter;
			sqlParameter = new SqlParameter( "@orderid", SqlDbType.Int );
			sqlParameter.Value = OrderId;

			return Open( "BEELDBANK_CUSTOM_ORDERREGEL_SELECT_SHOW_FROM_ORDERID", sqlParameter );
		}
	}
}
